CREATE ASSEMBLY [TextFunctions]
AUTHORIZATION [dbo]
FROM 'c:\SqlAssembly\TextFunctions.dll' WITH PERMISSION_SET = SAFE GO CREATE FUNCTION Levenstein(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.Levenstein
GO CREATE FUNCTION NeedlemanWunch(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.NeedlemanWunch
GO CREATE FUNCTION SmithWaterman(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.SmithWaterman
GO CREATE FUNCTION SmithWatermanGotoh(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.SmithWatermanGotoh
GO CREATE FUNCTION SmithWatermanGotohWindowedAffine(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.SmithWatermanGotohWindowedAffine
GO CREATE FUNCTION Jaro(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.Jaro
GO CREATE FUNCTION JaroWinkler(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.JaroWinkler
GO CREATE FUNCTION ChapmanLengthDeviation(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.ChapmanLengthDeviation
GO CREATE FUNCTION ChapmanMeanLength(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.ChapmanMeanLength
GO CREATE FUNCTION QGramsDistance(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.QGramsDistance
GO CREATE FUNCTION BlockDistance(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.BlockDistance
GO CREATE FUNCTION CosineSimilarity(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.CosineSimilarity
GO CREATE FUNCTION DiceSimilarity(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.DiceSimilarity
GO CREATE FUNCTION EuclideanDistance(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.EuclideanDistance
GO CREATE FUNCTION JaccardSimilarity(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.JaccardSimilarity
GO CREATE FUNCTION MatchingCoefficient(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.MatchingCoefficient
GO CREATE FUNCTION MongeElkan(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.MongeElkan
GO CREATE FUNCTION OverlapCoefficient(@firstword NVARCHAR(255),@secondword NVARCHAR(255)) RETURNS float EXTERNAL NAME TextFunctions.StringMetrics.OverlapCoefficient
GO 